save toto repl
delete from plan_table
where  statement_id='XXX';
commit;
get toto nolist

1

ch //explain plan set statement_id='XXX' for /
/
set linesize 110
column operation format a16
column options format a15
column object_name  format a20
column id  format 99
column p_id  format 99
column plan  format a110
select --ID, PARENT_ID P_ID,
       lpad(' ',2*(level-1))||operation||' '||options||' '||object_name||' '||
       -- decode(partition_id, NULL, '',
       --         'PART:'||lower(partition_start||'-'||partition_stop))||
       decode(optimizer, NULL, '', ' ['||optimizer||']')||
       decode(id,0,' Cost=' ||nvl(position,   0)||
                   ' Rows=' ||nvl(cardinality,0)||
                   ' Bytes='||nvl(bytes,      0)) "Plan"
from   plan_table
where                                statement_id = 'XXX'
start   with     id = 0          and statement_id = 'XXX'
connect by prior id = parent_id  and statement_id = 'XXX';

get toto nolist
